regexp to find string in SQL

PHOTO EMBED

Mon Apr 11 2022 04:35:26 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

select * from pizza_runner.tes as t
--use ~ to find string and use | to seperate between
where lower("name") ~ 'samantha|castor|norman|atkinson'
--use similiar to and put the =t(true) to find string, can use % 
where lower("name") similar to 'samantha%|%stanley'='t'
content_copyCOPY