gogetsome
asked on
Help with Select statement
Hello, I have a column like this:
RK PK XX
INS CHI BIO
EDU GEN HSM
HLT SUP GEN
TNI STB PSZ
EDU SCI CSC
PT WO XX
How do I perform a select statement and pull all rows that contain 'EDU'
select * from products where category = '%EDU%' --does not work
RK PK XX
INS CHI BIO
EDU GEN HSM
HLT SUP GEN
TNI STB PSZ
EDU SCI CSC
PT WO XX
How do I perform a select statement and pull all rows that contain 'EDU'
select * from products where category = '%EDU%' --does not work
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade. Good luck with your project. -Jim