SQL Queries

use sql_store;

select * from customers;

select address

from customers

where address like '%Trail%' or 

      address like '%Avenue%';

select phone

from customers

where phone like '%9';

select last_name

from customers

where last_name like '%y%';

select last_name

from customers

where last_name regexp 'y';

select last_name

from customers

where last_name regexp '^b';

select last_name

from customers

where last_name regexp 'field$';

select last_name

from customers

where last_name regexp 'dell$';

select last_name

from customers

where last_name regexp '^rose';

select last_name

from customers

where last_name regexp 'rose|field|dell';

select last_name

from customers

where last_name regexp '^rose|^field|dell';

select last_name

from customers

where last_name regexp 'rose$|field$|dell';

select last_name

from customers

where last_name regexp 'y';

select last_name

from customers

where last_name regexp '[ea]y';

select last_name

from customers

where last_name regexp '[fw]i';

select last_name

from customers

where last_name regexp '[fw]i[d]';

select last_name

from customers

where last_name regexp 'i[de]';

select last_name

from customers

where last_name regexp 'i[a-h]';

select first_name

from customers

where first_name regexp 'i[a-h]';

select first_name

from customers

where first_name regexp 'elka|ambur';

select last_name

from customers

where last_name regexp 'ey$|on$';

select last_name

from customers

where last_name regexp '^my|^se';

select last_name

from customers

where last_name regexp 'b[ru]';