19817/find-values-in-a-comma-separated-string-in-a-mysql-query
You can add commas to the left and right:
select * from shirts where CONCAT(',', colors, ',') like '%,1,%'
But you can also try out the below option:
select * from shirts where find_in_set('1',colors) <> 0
To find MySQL query values in a comma-separated ...READ MORE
From the version 5.1.7 onward, MySQL allows ...READ MORE
use this code: CREATE TRIGGER sample_trigger_msg ...READ MORE
Use the below code to list number of ...READ MORE
The reasons are as follows: The MySQL extension: Does ...READ MORE
Please check the below-mentioned syntax and commands: To ...READ MORE
using MySql.Data; using MySql.Data.MySqlClient; namespace Data { ...READ MORE
There are a lot of ways to ...READ MORE
You can try out the following query: INSERT ...READ MORE
To display the name of the employees ...READ MORE
OR
Already have an account? Sign in.