Select rows where column contains character from list
Discuss coding issues, and scripts related to PHP and MySQL.
-
MarPlo
- Posts: 186
Select rows where column contains character from list
I am trying to select all rows from a table where column contains a character from a list: Something like:
Code: Select all
SELECT * FROM table WHERE column (contains anything from {£,$,%,^,&,*,/} )
This is basically an illegal character check.
Can anyone help?
Thanks.
Admin
Posts: 805
Try with REGEXP, and escape everything with backslash. Result: [\£\$\%\^\&\*\?].
SQL:
Code: Select all
SELECT * FROM table WHERE column REGEXP '[\£\$\%\^\&\*\?]'
Similar Topics
-
Multiple select for upload not working on mobile
JavaScript - jQuery - Ajax
First post
Plessant Coursesweb,
meight useless to ask but it seems this upload for picture-album is not working on my mobile-page
but on my computer I just...
Last post
Try to search on the internet for:
html multiple select upload mobile