Question

mysql

Imagine ,you have a table named as 'accounts' table, where you have a column names as 'usernames'. So, find all the usernames that contain the letters “r” followed by “a” followed by “g” in that order anywhere in the string. a. Example: radiogenius should match OR iamaradiogenius

Answer 1

create table accounts(usernames varchar(20));

insert into accounts values('radiogenius');
insert into accounts values('iamaradiogenius');
insert into accounts values('notgenius');
insert into accounts values('iamnotgenius');
select * from accounts;
usernames
-----------
radiogenius
iamaradioge
notgenius
iamnotgeniu

query

select usernames from accounts where usernames LIKE '%r%a%g%';
usernames
-----------
radiogenius
iamaradioge