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!

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

    Advanced Zone Editor & Simple Zone Editor

    fastr, Dec 3, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    547
    fastr
    Dec 4, 2017
  2. jazee

    Simple Port Knock for WHM Web Login?

    jazee, Nov 7, 2017, in forum: Security
    Replies:
    4
    Views:
    358
    jazee
    Nov 8, 2017
  3. electric

    Unable to create simple .php file for paper_lantern

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

    Simple Backup Script

    furquan, Jul 18, 2017, in forum: Data Protection
    Replies:
    3
    Views:
    538
    cPanelMichael
    Jul 18, 2017
  5. 34ever

    Upgraded to MySQL 8.0 issue

    34ever, Dec 14, 2018 at 6:09 AM, in forum: EasyApache
    Replies:
    3
    Views:
    107
    cPanelMichael
    Dec 14, 2018 at 10:36 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice