searching part of a database field?

adamhhh1

is there a way to do this?

ive looked around and cant find much.

What i have is a massive log file and ive tried extracting using Excel, Word etc but it doesnt work effectively.

say in one database field i have:

/index.php menu_id=1116 80 - 194.152.95.202 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) 200 0 0 14775 526

I then need to extract and return just the menu_id=x and return x in a variable, any ideas how to go about this?

i dont think i could use preg_replace as the data isnt consistent.

Piranha

Well, first thing is that you really should think about your database design. Read up on database normalization to get to know why.

Second it is possible to get it with regex. I am in no way an expert, and won't even try to write the regex command. But search for what is between "menu_id=" and " " probably would work.

adamhhh1

and why do i need to think about my database design?

Piranha

adamhhh1 wrote:
and why do i need to think about my database design?

Piranha wrote:
Read up on database normalization to get to know why.

I am not your mother and won't do the work for you. I can come with suggestions, but it is up to you to follow them.

adamhhh1

..........