how to concatenate strings before executing??

#native_company# #native_desc#

#native_cta#

This site is best viewed in a modern browser with JavaScript enabled.

how to concatenate strings before executing??

ankit1122

i have an array of skills like skills1,skills2,skills3 etc etc.

i wanna make a query like

select * from tablenaame where skills regexp "skills1" and skills regexp "skills2" and skills regexp "skills3";

how can i do this withour errors??

howardbailey

I can do this thing in Python very easily. First declare a variables to the number of strings you want to concatenate and then assign each variable a string after that you can call your variables with adding a plus sign.

Suppose

var1 = "happy"
var2 = "mind"
var3 = "healthy mind"

print var1 + var2 + var3

It was a python code, you can have some idea from here and yes you are saying it should be before concatenate then its little different.

NogDog

At one level, I'm concerned about multiple regexp comparisons, as they will require full table reads, so I'm wondering if you might be better off with a FULLTEXT index/search? If you do need to do it the way you've described, I'll typically build another array of search expressions that can then be glued together, e.g.:

$search = array();
foreach($skills as $skill) {
    $search[] = "skill regexp '$skill'"; // but make sure you have sanitized $skill for your database extension!!!
}
$sql = "SELECT * FROM table_name WHERE ".implode(' AND ', $search);

deathshadow

I agree that regex is a bad idea -- so is blindly plugging in values to a query. If you were using PDO or mysqli, you can simply str_repeat a "?" pass in the query equal to the number of values in your $skills array.

$statement = $db->prepare('
  SELECT * FROM table_name
  WHERE' . str_repeat(' skill regexp ?', count($skills))
);

$statement->execute($skills);

Simpler, smaller, cleaner, faster. I really like PDO... especially since doing a prepare/exec means the values are sanitized ahead of time.