A simple reqular expression to replace sql conditional operators?

Question

I am writing a class to handle some MySql functions.
For now, I want a regular expression pattern to detect operations.
Please see my code:

$a = "user_id <> 2";


$generalOperators = "/[<>|[<][\sA-Za-z0-9]|>|<|=]([\sA-Za-z0-9])/";
$op = "$1";
$asd = preg_replace($generalOperators, $op, $a);
echo $asd;

This will echo user_id 2 as output!
I am new to regular expressions.
Thanks in advance!

What exactly output you want , are you saying that this script will give output or need something else — Afsar
– Afsar, Commented Jan 29, 2013 at 8:49

Rakesh Sharma · Accepted Answer · 2013-01-29 08:52:39Z

1

you can also use str_replace() add more item you want to replace

$in_str = str_replace(array('<', '>', '&', '{', '}', '*', '/', '(', '[', ']' , '@', '!', ')', '&', '*', '#', '$', '%', '^', '|','?', '+', '=','"',','), array(''), $str);

answered Jan 29, 2013 at 8:52

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Prasanth Bendra · Accepted Answer · 2013-01-29 08:44:55Z

0

$a    = "user_id <> 2";
$res  = preg_replace("/[<>]/","",$a);

echo $res;

answered Jan 29, 2013 at 8:44

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

1 Comment

Prasanth Bendra Over a year ago

What all other character you need to replace ?

Collectives™ on Stack Overflow

A simple reqular expression to replace sql conditional operators?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related