Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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. electric

    Unable to create simple .php file for paper_lantern

    electric, Sep 5, 2017, in forum: cPanel Developers
    Replies:
    3
    Views:
    99
    cPanelKenneth
    Sep 6, 2017
  2. furquan

    Simple Backup Script

    furquan, Jul 18, 2017, in forum: Data Protection
    Replies:
    3
    Views:
    115
    cPanelMichael
    Jul 18, 2017
  3. phillbooth

    PHP simplexml disabled

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

    Simple filter with AND not forwarding.

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

    Simple DNS question

    bloatedstoat, Jun 8, 2016, in forum: General Discussion
    Replies:
    4
    Views:
    532
    cPanelMichael
    Jun 14, 2016

Share This Page