Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to find string in the hole in MySQL Database ?

SQL
user-image
Question added by Moez SAAIDIA , CIO & Local Site Head , DATAMETRIX
Date Posted: 2014/02/21
Upvote (0) Views (3) Followers (0) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Moez SAAIDIA
by Moez SAAIDIA , CIO & Local Site Head , DATAMETRIX

thanks for your response, but my need is to find a string in all database's table into their respective colum. this function is present with phpmyadmin interface (rechearch) but i need the query to to this.

Deleted user
by Deleted user

SELECT*FROM items WHERE items.xmlLIKE'%123456%'try this is quiry.

Write Your Answer
More Questions Like This