CODEWITHSUNDEEP
phpmysqlsearch
PanasMedia
PanasMedia

Reputation: 11

Searching particular words in mysql field and return the value

I need help guys! Let me give an example here... Let say I have this two entries in 'comment' field of mysql..

 Entry 01: Kindly contact me through my email address [email protected]

 Entry 02: Please drop an email to [email protected] for more information

And i wanted to pull out only the email address from the entries. Anybody would be able to help me?

Thanks!

Upvotes: 1

Views: 134

Answers (1)

echo_Me
echo_Me

Reputation: 37233

try this

  SELECT * 
  FROM your_table 
  WHERE your_column_entry1 
  LIKE  '%nobody.com%' 
  OR your_column_entry2 LIKE '%you.com%'

Upvotes: 1

Related Questions