MySQL Query Finding Values In A Comma Separated String

SQL

Can anyone help me for finding values in a string with commas using MySQL?

1
Answers

Replies

Below is the SQL statement that can be used to find the MySQL query values in a comma-separated string.


select * from table_name where find_in_set('1',column_name) <> 0

 
 

If you want to unleash your potential in this competitive field, please visit the SQL course page for more information, where you can find the SQL tutorials and SQL frequently asked interview questions and answers as well.

 

This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.