MrTV
asked on
sql mysql to search record that not begin with
How can i search record that not be gin with 'abs' or 'cat' or 'f'a
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
where (not col like 'abs%' and not col like 'cat%' and not col like 'f''a%')
not sure if you deliberately meant f-dash-a
otherwise, the last part would be not col like 'f%'