Results 1 to 2 of 2

Thread: Mysql query to find email addresses

  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Mysql query to find email addresses

    Hi all,

    I'm new here and don't have much experiance with MySQL.
    my question is, is it possible to search a mysql database for email addresses ? and if so how should i form the query for it.

    a bit more specific i want to find everything within the database that has a @ sign..

    could someone help me with this.

    thanks

    Jeroen

  2. #2
    Join Date
    Feb 2006
    Posts
    4
    INSTR(str,substr)
    Returns the position of the first occurrence of substring substr in string str. This is the same as the two-argument form of LOCATE(), except that the arguments are swapped.
    mysql> SELECT INSTR('foobarbar', 'bar');
    -> 4
    mysql> SELECT INSTR('xbar', 'foobar');
    -> 0

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •