The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

simple MySQL query

Discussion in 'General Discussion' started by BigLebowski, Jun 1, 2009.

  1. BigLebowski

    BigLebowski Well-Known Member

    Joined:
    Dec 24, 2007
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    56
    hi there

    Quick question. I have a table full of char(255) rows with plain text in them. I wish to search through for any instance of four or 16 digits, eg
    1234 or 1234567812345678 or 1234-5678-1234-5678
    (I'm trying to locate credit card numbers).

    I'm a bit rusy on SQL. anyone suggest a select statement pls?

    The field is called "thread_content_part"

    Cheers
    Dude
     
    #1 BigLebowski, Jun 1, 2009
  2. elleryjh

    elleryjh Well-Known Member

    Joined:
    Apr 12, 2003
    Messages:
    479
    Likes Received:
    0
    Trophy Points:
    166
    Code:
    SELECT `thread_content_part` FROM `table_name` WHERE `thread_content_part` LIKE = '%1234%'
    or to select the whole row:

    Code:
    SELECT * FROM `table_name` WHERE `thread_content_part` LIKE = '%1234%'

    Of course replace table_name with the actual table name.
     
    #2 elleryjh, Jun 4, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - simple MySQL query
  1. furquan

    Simple Backup Script

    furquan, Jul 18, 2017 at 9:46 AM, in forum: Data Protection
    Replies:
    3
    Views:
    43
    cPanelMichael
    Jul 18, 2017 at 1:01 PM
  2. phillbooth

    PHP simplexml disabled

    phillbooth, Nov 23, 2016, in forum: EasyApache
    Replies:
    3
    Views:
    764
    SunHunter
    May 18, 2017
  3. Markqz

    Simple filter with AND not forwarding.

    Markqz, Aug 29, 2016, in forum: E-mail Discussions
    Replies:
    1
    Views:
    344
    cPanelMichael
    Aug 29, 2016
  4. bloatedstoat

    Simple DNS question

    bloatedstoat, Jun 8, 2016, in forum: General Discussion
    Replies:
    4
    Views:
    466
    cPanelMichael
    Jun 14, 2016
  5. jfall123

    Does anyone have a simple premade script for mass adding domains/databases

    jfall123, Apr 8, 2016, in forum: General Discussion
    Replies:
    3
    Views:
    8,701
    cPanelMichael
    Apr 11, 2016

Share This Page